To Use a Numeric Field

Create the table with one geometry column, one ID, one angle field, and one foreign key.

CREATE TABLE DEVICE
(ID NUMBER PRIMARY KEY,
LinkedID NUMBER,
Name VARCHAR2(50),
Geometry MDSYS.SDO_GEOMETRY);

Insert the table metadata in the Oracle Spatial metadata.

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES (‘DEVICE', 'Geometry',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)),
82247);

Create the spatial index of type point to be able to use the rotation.

CREATE INDEX DEVICE_IDX ON DEVICE(Geometry)
INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2 PARAMETERS ('layer_gtype=point');